All Questions
Tagged with entity-frameworkdesign-patterns
30 questions
1vote
2answers
202views
Designing Products with multiple variations
I have a Product entity: public class Product { public int Id { get; set; } public string? Name { get; set; } public string? Description { get; set; } [ForeignKey("Brand"...
1vote
1answer
63views
Pattern for schema split across sources
I was not sure how to title this question, but bear with me. My company is building a new product and for it we will use a third-party service (let's call it ENB for short) to be responsible for many ...
- 141
3votes
1answer
8kviews
How to avoid circular references with EF Core and Global Query Filters?
We're working on building a multitenant application, and we're using Entity Framework Core as our base data provider. With EF Core, you can use Global Query Filters to define custom filters that apply ...
- 1,387
1vote
1answer
350views
Call library functions with varying number of inputs while keeping API simple
For a ASP.NET Core application, I'm using a library which performs calculations using objects that have a similar interface but their constructors use different inputs. The inputs are market prices ...
0votes
1answer
199views
Venue Reservation System Logic Approach/Clarification
I hope this is the right place to ask since this is a programming related question. I’m developing a venue reservation app (similar to booking.com) and am almost done however I have 1 request for ...
- 103
2votes
0answers
68views
How to join two sets of 6 tables and select the list into another set of 6 tables
A1 |__A2 |__A3 |__A4 |__A5 B1 |__B2 |__B3 |__B4 |__B5 C1 |__C2 |__C3 |__C4 |__C5 Given a list of A and a list of B, we want to "join" the ...
- 207
20votes
3answers
10kviews
Should Entity Framework 6 not be used with repository pattern?
So I am asking this after reading the following: Why shouldn't I use the repository pattern with Entity Framework?. It seems there is a large split of people who say yay and those that say nay. ...
- 443
-1votes
1answer
236views
Patterns for loading related objects in memory (without an ORM)
I am using ADO.NET to read a bunch of data from the database into in-memory objects. This is my domain model: // Question.cs public class Question { public int ID { get; set; } public ...
31votes
5answers
12kviews
Pitfalls of Domain Driven Design with Entity Framework
A lot of tutorials on DDD I studied are mostly covering theory. They all have rudimentary code examples (Pluralsight and similar). On the web there are also attempts by a few people to create ...
- 495
3votes
1answer
2kviews
How should I design a 3-tier-architecture application with Entity Framework?
This is almost getting me crazy. EF bring us a very convenience experience in development. However, if we need to use the Entity model in the upper layer, we always put a reference from the upper ...
- 189
0votes
1answer
365views
How to properly wrap my data layer to communicate with business logic
I have an EF Core data layer and i want to wrap it around an interface to separte it from the business logic. Now the issue is that i am not sure i am doing it correctly. First, i was just using ...
-1votes
1answer
126views
Iteration inside a using or using inside an Iteration
Is there a best practice for iterations inside of a "using"? which is better? and maybe a why? "using" inside of an iteration... foreach (var currentPerson in Persons) { using (var db = new ...
- 47
1vote
2answers
3kviews
Storing a temporary data outside of DbContext in Entity Framework
I have a performance issue with a few methods in my Service Layer. Methods that are causing me troubles have some logic, but it's db connection that takes over 95% exec time. The problem is ...
- 267
7votes
1answer
13kviews
Generic repository pattern +EF and unit of work
I'm new to this Repository pattern and have seen lot of repository pattern + UoW implementations all over the internet and I'm not able to reach to a conclusion as to which of them is correct . After ...
2votes
1answer
183views
Reattachment of full entity graphs for frontend/backend applications which communicates using REST API/JSON?
I am trying to develop business application with separated backend (persistence, business logic, server side workflows) and frontend (presentation, some business logic) which communicates using REST ...
- 1,009
